Diagram UHCContracts_7

Defincja diagramu UHCContracts_7

Name

UHCContracts_7

Code

UHCContracts_7

Comment

 


Lista tabel diagramu

Name

Code

AccountData

AccountData

AccountingErrors

AccountingErrors

AccountTemplate

AccountTemplate

CalculationType

CalculationType

ChargeType

ChargeType

ContractService

ContractService

Declaration

Declaration

Dictionary

Dictionary

Episode

Episode

Event

Event

HealthProgramme

HealthProgramme

LAccountDataStatus

LAccountDataStatus

LDeclarationErrors

LDeclarationErrors

LDeclarationStatus

LDeclarationStatus

LMessage

LMessage

LPatientPOZDeclaration

LPatientPOZDeclaration

LPOZDeclarationReport

LPOZDeclarationReport

Message

Message

Patient

Patient

POZDeclarationReport

POZDeclarationReport

POZDeclarationType

POZDeclarationType

POZIdentificationType

POZIdentificationType

POZLicenceType

POZLicenceType

POZSchoolType

POZSchoolType

SchoolKind

SchoolKind


Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_118

R_118

ChargeType

Declaration

ChargeTypeID

 

 

R_121

R_121

POZDeclarationType

Declaration

POZDeclarationTypeID

 

 

R_122

R_122

SchoolKind

Declaration

SchoolKindID

 

 

R_124

R_124

Declaration

LPatientPOZDeclaration

DeclarationID

 

 

R_125

R_125

Patient

LPatientPOZDeclaration

PatientID

 

 

R_129

R_129

POZSchoolType

Declaration

POZSchoolTypeID

 

 

R_130

R_130

POZLicenceType

Declaration

POZLicenceTypeID

 

 

R_133

R_133

Message

POZDeclarationReport

MessageID

 

 

R_185

R_185

Message

LMessage

MessageID

 

 

R_186

R_186

Message

LMessage

Mes_MessageID

 

 

R_193

R_193

Declaration

LPOZDeclarationReport

DeclarationID

 

 

R_194

R_194

POZDeclarationReport

LPOZDeclarationReport

POZDeclarationReportID

 

 

R_200

R_200

ContractService

LDeclarationStatus

ContractServID

 

 

R_201

R_201

Declaration

LDeclarationStatus

DeclarationID

 

 

R_202

R_202

ContractService

LDeclarationStatus

Con_ContractServID

 

 

R_203

R_203

LDeclarationStatus

LDeclarationErrors

DeclarationStatusID

 

 

R_204

R_204

AccountingErrors

LDeclarationErrors

AccountingErrorsID

 

 

R_340

R_340

AccountingErrors

Message

AccountingErrorsID

 

 

R_480

R_480

LAccountDataStatus

AccountingErrors

AccountDataStatusID

 

 

R_481

R_481

Episode

AccountingErrors

EpisodeID

 

 

R_482

R_482

Event

AccountingErrors

EventID

 

 

R_483

R_483

AccountData

AccountingErrors

AccountDataID

 

 

R_580

R_580

HealthProgramme

Episode

HealtProgrammeID

 

 

R_593

R_593

AccountTemplate

LDeclarationStatus

AccountTemplateID

 

 

R_594

R_594

CalculationType

AccountTemplate

CalculationTypeID

 

 

R_602

R_602

Dictionary

LDeclarationStatus

CorrectionReason